l108/opdracht auteurdetails/boekinfo.php

<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>Document</title> <link rel="stylesheet" type="text/css" href="infostyle.css"> </head> <body> <?php include "../db.php"; include "../functions.php"; $boeknr = $_GET["boeknr"]; $result = mysqli_query($db, "SELECT * FROM boeken WHERE boeknr = $boeknr"); $values = mysqli_fetch_row($result); echo "<h1>$values[2]</h1>"; echo "<p>Gepubliceerd in $values[3]</p>"; $values2 = mysqli_fetch_row(mysqli_query($db, "SELECT voornaam, tussenvoegsel, achternaam, auteurnr FROM auteurs WHERE auteurnr = $values[1]")); echo "<p>Geschreven door <a href='auteurinfo.php?auteurnr=$values2[3]'>$values2[0] $values2[1] $values2[2]</a></p>"; echo "<p>Geleend door:</p>"; $result = mysqli_query($db, "SELECT DISTINCT leerlingen.* FROM leerlingen, uitleningen WHERE boeknr = $boeknr"); $returnedvalue = "<table>"; for($i = 0; $i < mysqli_num_rows($result); $i++){ $values = mysqli_fetch_array($result); $returnedvalue .= "<tr>"; for($j = 0; $j < count($values)/2; $j++){ if($j == 1){ $returnedvalue .= "<td><a href='leerlinginfo.php?llnr=$values[0]'>$values[$j]</a></td>"; } else{ $returnedvalue .= "<td>$values[$j]</td>"; } } $returnedvalue .= "</tr>"; } $returnedvalue .= "</table>"; $returnedvalue = str_replace("<table>", "<table style='border: 1px solid'>", $returnedvalue); $returnedvalue = str_replace("<td>", "<td style='border: 1px solid'>", $returnedvalue); echo $returnedvalue; //echo formattable($result, "border"); ?> <br><span><a href="boeken.php">Alle boeken</a></span> </body> </html>

Resultaat

Made by Thijs Aarnoudse